space
Previous Page | Next Page

SAS Namespace Types

PropertyType


Subclass of LocalizedType


Overview

Defines the data type of a property. Beginning with SAS 9.2, PropertyType is no longer a shared resource; instead, it is contained by the Property object that it helps to define. PropertyType is no longer considered to be an owning type. The SQL type of a Property object is now recorded in the SQLType attribute of the Property object. Use PropertyType when the SQL type is set to 1111 (other) or 2003 (array) and more detail is needed to describe the type.

Security Inheritance and Enforcement Rules

The following list of associations is used to determine if this object should inherit access controls from another object (inheritance), or if the association is allowed for the object (enforcement). An association will not be created unless the calling user is authorized to update one or both objects involved in the association. For more information about inheritance and enforcement rules, see the SAS Intelligence Platform: Security Administration Guide.

Attributes

Name Description Type Length
SQLType This is an integer value that identifies the SQL type of the data.
  • ARRAY = 2003
  • BIGINT = -5
  • BINARY = -2
  • BIT = -7
  • BLOB = 2004
  • CHAR = 1
  • CLOB = 2005
  • DATE = 91
  • DECIMAL = 3
  • DISTINCT = 2001
  • DOUBLE = 8
  • FLOAT = 6
  • INTEGER = 4
  • JAVA_OBJECT = 2000
  • LONGVARBINARY = -4
  • LONGVARCHAR = -1
  • NULL = 0
  • NUMERIC = 2
  • OTHER = 1111
  • REAL = 7
  • REF = 2006
  • SMALLINT = 5
  • STRUCT = 2002
  • TIME = 92
  • TIMESTAMP = 93
  • TINYINT = -6
  • VARBINARY = -3
  • VARCHAR = 12
  • QuotedString = 2200
  •  
    int  

    Inherited Attributes
    Name, Id, Desc, MetadataCreated, MetadataUpdated, ChangeState, LockedBy, UsageVersion

    Associations

    = indicates the resident side of an association, or where the association is persisted for cross-repository associations. If no resident side is indicated, this association may not cross repository boundaries.

    Name Cardinality Description Associated Types
    ArrayTypes

    Partner: ElementType

    0 to * The arrays that use this PropertyType.  PropertyType
    Customizers

    Partner: CustomizedTypes

    0 to * The programs used to customize this object. A customizer is a standalone editor used to customize or edit a value. It does not reside inside a UI element as an editor does, but defines it's own window. If none exists on the entity, the customizer of the property type is returned.  SoftwareComponent
    ConfiguredComponent
    DeployedComponent
    LogicalServer
    ServerComponent
    ServerContext
    ServiceComponent
    Editors

    Partner: EditedTypes

    0 to * The programs that can edit this object. The editor is a component that can be placed inside a UI container, such as a property sheet, and that edits the property value.  SoftwareComponent
    ConfiguredComponent
    DeployedComponent
    LogicalServer
    ServerComponent
    ServerContext
    ServiceComponent
    ElementType

    Partner: ArrayTypes

    0 to 1 The PropertyType used in this array.  PropertyType
    StoredConfiguration

    Partner: AssociatedType

    0 to 1 The configuration information for this object.  Text
    ArchiveEntry
    ArchiveFile
    Document
    File
    SASCatalogEntry
    TextStore
    TypedAttProperties

    Partner: OwningType

    0 to * The attribute properties that are of this type.  AttributeProperty
    TypedProperties

    Partner: OwningType

    0 to * The properties that are of this type.  Property
    Validators

    Partner: ValidatedTypes

    0 to * The programs used to validate the value of this PropertyType.  SoftwareComponent
    ConfiguredComponent
    DeployedComponent
    LogicalServer
    ServerComponent
    ServerContext
    ServiceComponent

    Inherited Associations
    AccessControls/Objects, Changes/Objects, CustomAssociations/OwningObject, Documents/Objects, Extensions/OwningObject, ExternalIdentities/OwningObject, Groups/Members, Implementors/ImplementedObjects, Keywords/Objects, LocalizedAttributes/AssociatedLocalizedObject, Notes/Objects, PrimaryPropertyGroup/AssociatedObject, Prompts/PromptEnabledObject, Properties/AssociatedObject, PropertySets/OwningObject, ReferencedObjects/AssociatedObjects, Resources/LocalizedObject, ResponsibleParties/Objects, SourceTransformations/TransformationSources, SpecSourceTransformations/SourceSpecifications, SpecTargetTransformations/TargetSpecifications, TargetTransformations/TransformationTargets, Timestamps/Objects, Trees/Members, TSObjectNamespace/TSObjects, UsedByPrototypes/UsingPrototype, UsingPrototype/UsedByPrototypes, Variables/AssociatedObject

    Attribute Details

    SQLType
         Type:  int  

    This is an integer value that identifies the SQL type of the data.

  • ARRAY = 2003
  • BIGINT = -5
  • BINARY = -2
  • BIT = -7
  • BLOB = 2004
  • CHAR = 1
  • CLOB = 2005
  • DATE = 91
  • DECIMAL = 3
  • DISTINCT = 2001
  • DOUBLE = 8
  • FLOAT = 6
  • INTEGER = 4
  • JAVA_OBJECT = 2000
  • LONGVARBINARY = -4
  • LONGVARCHAR = -1
  • NULL = 0
  • NUMERIC = 2
  • OTHER = 1111
  • REAL = 7
  • REF = 2006
  • SMALLINT = 5
  • STRUCT = 2002
  • TIME = 92
  • TIMESTAMP = 93
  • TINYINT = -6
  • VARBINARY = -3
  • VARCHAR = 12
  • QuotedString = 2200
  • Association Details

    ArrayTypes
         Cardinality:   0 to *
         Partner:   ElementType

    The arrays that use this PropertyType. 

    Associated Types:
    PropertyType

    Customizers
         Cardinality:   0 to *
         Partner:   CustomizedTypes

    The programs used to customize this object. A customizer is a standalone editor used to customize or edit a value. It does not reside inside a UI element as an editor does, but defines it's own window. If none exists on the entity, the customizer of the property type is returned. 

    Associated Types:
    SoftwareComponent, ConfiguredComponent, DeployedComponent, LogicalServer, ServerComponent, ServerContext, ServiceComponent

    Editors
         Cardinality:   0 to *
         Partner:   EditedTypes

    The programs that can edit this object. The editor is a component that can be placed inside a UI container, such as a property sheet, and that edits the property value. 

    Associated Types:
    SoftwareComponent, ConfiguredComponent, DeployedComponent, LogicalServer, ServerComponent, ServerContext, ServiceComponent

    ElementType
         Cardinality:   0 to 1
         Partner:   ArrayTypes

    The PropertyType used in this array. 

    Associated Types:
    PropertyType

    StoredConfiguration
         Cardinality:   0 to 1
         Partner:   AssociatedType

    The configuration information for this object. 

    Associated Types:
    Text, ArchiveEntry, ArchiveFile, Document, File, SASCatalogEntry, TextStore

    TypedAttProperties
         Cardinality:   0 to *
         Partner:   OwningType

    The attribute properties that are of this type. 

    Associated Types:
    AttributeProperty

    TypedProperties
         Cardinality:   0 to *
         Partner:   OwningType

    The properties that are of this type. 

    Associated Types:
    Property

    Validators
         Cardinality:   0 to *
         Partner:   ValidatedTypes

    The programs used to validate the value of this PropertyType. 

    Associated Types:
    SoftwareComponent, ConfiguredComponent, DeployedComponent, LogicalServer, ServerComponent, ServerContext, ServiceComponent

    Previous Page | Next Page | Top of Page